declare @username varchar(100)
declare @presenterid int
declare @userid uniqueidentifier

-- change to whatever user you want to remove.
set @username = 'Test'

-- Remove presenter info, sessions

select @presenterid = Id from CodeCamp00.Presenters where UserIdentityName = @username

delete from CodeCamp00.Sessions where PresenterId = @presenterid
delete from CodeCamp00.Presenters where Id = @presenterid

-- Remove membership info, user

select @userid = UserId from aspnet_Users where UserName = @username

delete from aspnet_UsersInRoles where UserId = @userid
delete from aspnet_Membership where UserId = @userid
delete from aspnet_Users where UserId = @userid
